/*
 Navicat Premium Data Transfer

 Source Server         : 我的本地
 Source Server Type    : MySQL
 Source Server Version : 50728 (5.7.28)
 Source Host           : localhost:3306
 Source Schema         : lv_blank

 Target Server Type    : MySQL
 Target Server Version : 50728 (5.7.28)
 File Encoding         : 65001

 Date: 10/06/2025 20:54:34
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for ky_black_card
-- ----------------------------
DROP TABLE IF EXISTS `ky_black_card`;
CREATE TABLE `ky_black_card` (
  `card_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '卡片ID',
  `card_no` varchar(32) NOT NULL COMMENT '卡号(HK开头)',
  `card_type` enum('personal','organization') NOT NULL COMMENT '卡片类型：个人/机构',
  `user_id` bigint(20) DEFAULT NULL COMMENT '所属会员ID',
  `org_id` bigint(20) DEFAULT NULL COMMENT '所属机构ID',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '卡片状态：0-未使用 1-已使用 2-禁用',
  `bind_time` timestamp NULL DEFAULT NULL COMMENT '绑定时间',
  `use_time` timestamp NULL DEFAULT NULL COMMENT '首次使用时间',
  `balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '总额度',
  `effect_time` timestamp NULL DEFAULT NULL COMMENT '生效时间',
  `available_balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '可用额度',
  `frozen_balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '冻结额度',
  `total_consumption` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '累计消费',
  `daily_limit` decimal(12,2) DEFAULT NULL COMMENT '日消费限额',
  `monthly_limit` decimal(12,2) DEFAULT NULL COMMENT '月消费限额',
  `generate_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '生成时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`card_id`),
  UNIQUE KEY `idx_card_no` (`card_no`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_org_id` (`org_id`),
  CONSTRAINT `fk_card_org` FOREIGN KEY (`org_id`) REFERENCES `ky_organization` (`org_id`) ON DELETE SET NULL,
  CONSTRAINT `fk_card_user` FOREIGN KEY (`user_id`) REFERENCES `ky_user` (`user_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COMMENT='黑卡表';

-- ----------------------------
-- Records of ky_black_card
-- ----------------------------
BEGIN;
INSERT INTO `ky_black_card` (`card_id`, `card_no`, `card_type`, `user_id`, `org_id`, `status`, `bind_time`, `use_time`, `balance`, `effect_time`, `available_balance`, `frozen_balance`, `total_consumption`, `daily_limit`, `monthly_limit`, `generate_time`, `remark`, `created_at`, `updated_at`) VALUES (1, 'HK20250610087975938', 'organization', NULL, 2, 0, NULL, NULL, 0.00, '2025-06-10 07:21:58', 0.00, 0.00, 0.00, 0.00, 0.00, '2025-06-10 15:41:22', NULL, '2025-06-10 15:41:22', '2025-06-10 15:41:22');
INSERT INTO `ky_black_card` (`card_id`, `card_no`, `card_type`, `user_id`, `org_id`, `status`, `bind_time`, `use_time`, `balance`, `effect_time`, `available_balance`, `frozen_balance`, `total_consumption`, `daily_limit`, `monthly_limit`, `generate_time`, `remark`, `created_at`, `updated_at`) VALUES (2, 'HK20250610885772119', 'organization', NULL, 2, 0, NULL, NULL, 0.00, '2025-06-10 07:21:58', 0.00, 0.00, 0.00, 0.00, 0.00, '2025-06-10 15:42:34', NULL, '2025-06-10 15:42:34', '2025-06-10 15:42:34');
INSERT INTO `ky_black_card` (`card_id`, `card_no`, `card_type`, `user_id`, `org_id`, `status`, `bind_time`, `use_time`, `balance`, `effect_time`, `available_balance`, `frozen_balance`, `total_consumption`, `daily_limit`, `monthly_limit`, `generate_time`, `remark`, `created_at`, `updated_at`) VALUES (3, 'HK20250610317709631', 'organization', NULL, 2, 0, NULL, NULL, 100000.00, '2025-06-10 07:21:58', 100000.00, 0.00, 0.00, 0.00, 0.00, '2025-06-10 15:45:00', NULL, '2025-06-10 15:45:00', '2025-06-10 17:42:28');
COMMIT;

-- ----------------------------
-- Table structure for ky_black_card_recharge
-- ----------------------------
DROP TABLE IF EXISTS `ky_black_card_recharge`;
CREATE TABLE `ky_black_card_recharge` (
  `recharge_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '充值ID',
  `recharge_type` enum('personal','organization') NOT NULL COMMENT '充值类型：个人/机构',
  `org_id` bigint(20) DEFAULT NULL COMMENT '机构ID',
  `recharge_no` varchar(32) NOT NULL COMMENT '充值单号',
  `black_card_id` bigint(20) NOT NULL COMMENT '黑卡ID',
  `black_card_no` varchar(32) NOT NULL COMMENT '黑卡卡号',
  `amount` decimal(12,2) NOT NULL COMMENT '充值金额',
  `payment_method` enum('bank','other') NOT NULL DEFAULT 'bank' COMMENT '支付方式：对公/其他',
  `payment_account` varchar(50) DEFAULT NULL COMMENT '付款账号',
  `payment_bank` varchar(100) DEFAULT NULL COMMENT '付款银行',
  `payment_time` datetime DEFAULT NULL COMMENT '付款时间',
  `verify_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '核实状态：0-未核实 1-已核实',
  `verify_time` datetime DEFAULT NULL COMMENT '核实时间',
  `effect_time` datetime DEFAULT NULL COMMENT '生效时间',
  `status` enum('pending','success','failed') NOT NULL DEFAULT 'pending' COMMENT '状态：充值中/成功/失败',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`recharge_id`),
  UNIQUE KEY `idx_recharge_no` (`recharge_no`),
  KEY `idx_black_card` (`black_card_id`),
  KEY `idx_black_card_no` (`black_card_no`),
  KEY `idx_org_id` (`org_id`),
  CONSTRAINT `fk_recharge_black_card` FOREIGN KEY (`black_card_no`) REFERENCES `ky_black_card` (`card_no`) ON DELETE NO ACTION,
  CONSTRAINT `fk_recharge_org` FOREIGN KEY (`org_id`) REFERENCES `ky_organization` (`org_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='黑卡充值记录表';

-- ----------------------------
-- Records of ky_black_card_recharge
-- ----------------------------
BEGIN;
INSERT INTO `ky_black_card_recharge` (`recharge_id`, `recharge_type`, `org_id`, `recharge_no`, `black_card_id`, `black_card_no`, `amount`, `payment_method`, `payment_account`, `payment_bank`, `payment_time`, `verify_status`, `verify_time`, `effect_time`, `status`, `remark`, `created_at`, `updated_at`) VALUES (1, 'organization', 2, 'RC202506101734055597', 3, 'HK20250610317709631', 100000.00, 'bank', '3959342859', '农行鄂尔多斯天赋支行', '2025-06-06 00:00:00', 1, '2025-06-10 17:42:28', '2025-06-10 17:42:28', 'success', '测试充值', '2025-06-10 17:34:05', '2025-06-10 17:42:28');
COMMIT;

-- ----------------------------
-- Table structure for ky_butler
-- ----------------------------
DROP TABLE IF EXISTS `ky_butler`;
CREATE TABLE `ky_butler` (
  `butler_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '管家ID',
  `name` varchar(50) NOT NULL COMMENT '管家姓名',
  `phone` varchar(20) NOT NULL COMMENT '联系电话',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `scenic_spot_id` bigint(20) DEFAULT NULL COMMENT '所属景区ID',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0-离职 1-在职',
  `service_level` enum('senior','expert','master') NOT NULL COMMENT '服务级别',
  `rating` decimal(2,1) DEFAULT '5.0' COMMENT '服务评分',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`butler_id`),
  KEY `idx_scenic_spot` (`scenic_spot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管家信息表';

-- ----------------------------
-- Records of ky_butler
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_card_balance_log
-- ----------------------------
DROP TABLE IF EXISTS `ky_card_balance_log`;
CREATE TABLE `ky_card_balance_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `card_id` bigint(20) NOT NULL COMMENT '黑卡ID',
  `card_no` varchar(32) NOT NULL COMMENT '黑卡号',
  `change_type` enum('recharge','allocate','recover','consume','refund','freeze','unfreeze') NOT NULL COMMENT '变更类型',
  `amount` decimal(12,2) NOT NULL COMMENT '变更金额',
  `before_balance` decimal(12,2) NOT NULL COMMENT '变更前余额',
  `after_balance` decimal(12,2) NOT NULL COMMENT '变更后余额',
  `before_available` decimal(12,2) NOT NULL COMMENT '变更前可用额度',
  `after_available` decimal(12,2) NOT NULL COMMENT '变更后可用额度',
  `before_frozen` decimal(12,2) NOT NULL COMMENT '变更前冻结额度',
  `after_frozen` decimal(12,2) NOT NULL COMMENT '变更后冻结额度',
  `related_id` varchar(32) DEFAULT NULL COMMENT '关联单号',
  `operator_id` bigint(20) NOT NULL COMMENT '操作人ID',
  `operator_name` varchar(50) NOT NULL COMMENT '操作人姓名',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`log_id`),
  KEY `idx_card_id` (`card_id`),
  KEY `idx_card_no` (`card_no`),
  KEY `idx_operator` (`operator_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='黑卡额度变更记录表';

-- ----------------------------
-- Records of ky_card_balance_log
-- ----------------------------
BEGIN;
INSERT INTO `ky_card_balance_log` (`log_id`, `card_id`, `card_no`, `change_type`, `amount`, `before_balance`, `after_balance`, `before_available`, `after_available`, `before_frozen`, `after_frozen`, `related_id`, `operator_id`, `operator_name`, `remark`, `created_at`) VALUES (1, 3, 'HK20250610317709631', 'recharge', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, NULL, 0, '系统', '新建黑卡', '2025-06-10 15:45:00');
INSERT INTO `ky_card_balance_log` (`log_id`, `card_id`, `card_no`, `change_type`, `amount`, `before_balance`, `after_balance`, `before_available`, `after_available`, `before_frozen`, `after_frozen`, `related_id`, `operator_id`, `operator_name`, `remark`, `created_at`) VALUES (2, 3, 'HK20250610317709631', 'recharge', 100000.00, 0.00, 100000.00, 0.00, 100000.00, 0.00, 0.00, NULL, 0, '系统', '充值单号：RC202506101734055597', '2025-06-10 17:42:28');
COMMIT;

-- ----------------------------
-- Table structure for ky_card_no_sequence
-- ----------------------------
DROP TABLE IF EXISTS `ky_card_no_sequence`;
CREATE TABLE `ky_card_no_sequence` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `prefix` varchar(10) NOT NULL COMMENT '卡号前缀',
  `current_value` int(11) NOT NULL DEFAULT '0' COMMENT '当前序号值',
  `step` int(11) NOT NULL DEFAULT '1' COMMENT '步进值',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_prefix` (`prefix`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='黑卡号生成规则表';

-- ----------------------------
-- Records of ky_card_no_sequence
-- ----------------------------
BEGIN;
INSERT INTO `ky_card_no_sequence` (`id`, `prefix`, `current_value`, `step`, `created_at`, `updated_at`) VALUES (1, 'HK', 0, 1, '2025-06-04 11:51:32', '2025-06-04 11:51:32');
COMMIT;

-- ----------------------------
-- Table structure for ky_card_quota_allocation
-- ----------------------------
DROP TABLE IF EXISTS `ky_card_quota_allocation`;
CREATE TABLE `ky_card_quota_allocation` (
  `allocation_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分配ID',
  `allocation_no` varchar(32) NOT NULL COMMENT '分配单号',
  `primary_card_id` bigint(20) NOT NULL COMMENT '主卡ID',
  `primary_card_no` varchar(32) NOT NULL COMMENT '主卡卡号',
  `sub_card_id` bigint(20) NOT NULL COMMENT '子卡ID',
  `sub_card_no` varchar(32) NOT NULL COMMENT '子卡卡号',
  `amount` decimal(12,2) NOT NULL COMMENT '分配金额',
  `quota_type` enum('fixed','shared') NOT NULL COMMENT '额度类型',
  `operation_type` enum('allocate','recover','adjust') NOT NULL COMMENT '操作类型：分配/收回/调整',
  `before_amount` decimal(12,2) NOT NULL COMMENT '操作前金额',
  `after_amount` decimal(12,2) NOT NULL COMMENT '操作后金额',
  `operator_id` bigint(20) NOT NULL COMMENT '操作人ID',
  `operator_name` varchar(50) NOT NULL COMMENT '操作人姓名',
  `status` enum('pending','success','failed') NOT NULL DEFAULT 'pending' COMMENT '分配状态',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`allocation_id`),
  UNIQUE KEY `idx_allocation_no` (`allocation_no`),
  KEY `idx_primary_card` (`primary_card_id`),
  KEY `idx_sub_card` (`sub_card_id`),
  KEY `idx_operator` (`operator_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='黑卡额度分配记录表';

-- ----------------------------
-- Records of ky_card_quota_allocation
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_card_recharge
-- ----------------------------
DROP TABLE IF EXISTS `ky_card_recharge`;
CREATE TABLE `ky_card_recharge` (
  `recharge_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '充值ID',
  `recharge_no` varchar(32) NOT NULL COMMENT '充值单号',
  `card_id` bigint(20) NOT NULL COMMENT '黑卡ID',
  `card_no` varchar(32) NOT NULL COMMENT '黑卡号',
  `amount` decimal(12,2) NOT NULL COMMENT '充值金额',
  `payment_type` enum('bank_transfer','other') NOT NULL DEFAULT 'bank_transfer' COMMENT '支付方式',
  `payment_account` varchar(100) DEFAULT NULL COMMENT '付款账号',
  `payment_bank` varchar(100) DEFAULT NULL COMMENT '付款银行',
  `payment_time` timestamp NULL DEFAULT NULL COMMENT '付款时间',
  `verify_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '核实状态：0-待核实 1-已核实',
  `verify_user_id` bigint(20) DEFAULT NULL COMMENT '核实人ID',
  `verify_time` timestamp NULL DEFAULT NULL COMMENT '核实时间',
  `effect_time` timestamp NULL DEFAULT NULL COMMENT '生效时间',
  `status` enum('pending','success','failed') NOT NULL DEFAULT 'pending' COMMENT '充值状态',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`recharge_id`),
  UNIQUE KEY `idx_recharge_no` (`recharge_no`),
  KEY `idx_card_id` (`card_id`),
  KEY `idx_card_no` (`card_no`),
  CONSTRAINT `fk_recharge_card` FOREIGN KEY (`card_id`) REFERENCES `ky_black_card` (`card_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='黑卡充值记录表';

-- ----------------------------
-- Records of ky_card_recharge
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_emergency_service
-- ----------------------------
DROP TABLE IF EXISTS `ky_emergency_service`;
CREATE TABLE `ky_emergency_service` (
  `service_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '服务ID',
  `user_id` bigint(20) NOT NULL COMMENT '会员ID',
  `butler_id` bigint(20) NOT NULL COMMENT '处理管家ID',
  `scenic_spot_id` bigint(20) NOT NULL COMMENT '景区ID',
  `type` enum('accident','medical','weather','schedule','other') NOT NULL COMMENT '紧急类型',
  `status` enum('pending','processing','completed','cancelled') NOT NULL COMMENT '处理状态',
  `description` text NOT NULL COMMENT '事件描述',
  `solution` text COMMENT '处理方案',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '发生时间',
  `response_time` timestamp NULL DEFAULT NULL COMMENT '响应时间',
  `end_time` timestamp NULL DEFAULT NULL COMMENT '处理完成时间',
  `rating` tinyint(1) DEFAULT NULL COMMENT '服务评分',
  `feedback` text COMMENT '服务评价',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`service_id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_butler_id` (`butler_id`),
  KEY `idx_scenic_spot` (`scenic_spot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='紧急服务记录表';

-- ----------------------------
-- Records of ky_emergency_service
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_goods
-- ----------------------------
DROP TABLE IF EXISTS `ky_goods`;
CREATE TABLE `ky_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '商品ID',
  `type` tinyint(1) NOT NULL DEFAULT '1' COMMENT '商品类型：1普通商品，2服务商品',
  `category_id` int(11) NOT NULL COMMENT '分类ID',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `name` varchar(100) NOT NULL COMMENT '商品名称',
  `price` decimal(10,2) NOT NULL COMMENT '零售价格',
  `original_price` decimal(10,2) DEFAULT NULL COMMENT '参考进价',
  `member_price` decimal(10,2) DEFAULT NULL COMMENT '会员特价',
  `points_rule` varchar(50) DEFAULT NULL COMMENT '积分方式',
  `points_value` decimal(10,2) DEFAULT NULL COMMENT '积分值',
  `discount_rule` varchar(50) DEFAULT NULL COMMENT '最低折扣',
  `discount_value` decimal(10,2) DEFAULT NULL COMMENT '折扣值',
  `unit` varchar(20) DEFAULT NULL COMMENT '单位',
  `spec` varchar(50) DEFAULT NULL COMMENT '规格',
  `stock` int(11) NOT NULL DEFAULT '0' COMMENT '库存数量',
  `sales_count` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
  `min_stock` int(11) NOT NULL DEFAULT '0' COMMENT '最低库存',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1上架，0下架',
  `image` varchar(255) DEFAULT NULL COMMENT '商品图片',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注说明',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `idx_code` (`code`) USING BTREE,
  KEY `idx_category` (`category_id`) USING BTREE,
  CONSTRAINT `fk_goods_category` FOREIGN KEY (`category_id`) REFERENCES `ky_goods_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='商品表';

-- ----------------------------
-- Records of ky_goods
-- ----------------------------
BEGIN;
INSERT INTO `ky_goods` (`id`, `type`, `category_id`, `code`, `name`, `price`, `original_price`, `member_price`, `points_rule`, `points_value`, `discount_rule`, `discount_value`, `unit`, `spec`, `stock`, `sales_count`, `min_stock`, `status`, `image`, `remark`, `created_at`, `updated_at`) VALUES (2, 1, 1, '5646545', '大床房', 168.00, 0.00, 0.00, '', 0.00, '', 0.00, '间', '', 100, 26, 1, 1, '', '', '2025-01-16 22:26:39', '2025-02-14 13:07:57');
COMMIT;

-- ----------------------------
-- Table structure for ky_goods_category
-- ----------------------------
DROP TABLE IF EXISTS `ky_goods_category`;
CREATE TABLE `ky_goods_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '父级ID',
  `name` varchar(50) NOT NULL COMMENT '分类名称',
  `level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '层级',
  `path` varchar(255) DEFAULT '' COMMENT '分类路径',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序（数字越大越靠前）',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1启用，0禁用',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_parent` (`parent_id`) USING BTREE,
  KEY `idx_level` (`level`) USING BTREE,
  KEY `idx_path` (`path`(191)) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='商品分类表';

-- ----------------------------
-- Records of ky_goods_category
-- ----------------------------
BEGIN;
INSERT INTO `ky_goods_category` (`id`, `parent_id`, `name`, `level`, `path`, `sort`, `status`, `created_at`, `updated_at`) VALUES (1, 0, '酒店', 1, '', 0, 1, '2025-01-16 19:11:29', '2025-01-16 19:11:29');
COMMIT;

-- ----------------------------
-- Table structure for ky_member
-- ----------------------------
DROP TABLE IF EXISTS `ky_member`;
CREATE TABLE `ky_member` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '会员姓名',
  `phone` varchar(20) NOT NULL COMMENT '手机号',
  `level` int(11) NOT NULL DEFAULT '1' COMMENT '会员等级',
  `balance` decimal(10,2) NOT NULL COMMENT '余额',
  `points` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `store_id` int(11) NOT NULL COMMENT '所属门店',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0禁用 1启用',
  `birthday` date DEFAULT NULL COMMENT '会员生日',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `wechat` varchar(50) DEFAULT NULL COMMENT '微信绑定',
  `points_account` decimal(10,2) DEFAULT NULL COMMENT '积分账户',
  `card_times` int(11) DEFAULT '0' COMMENT '卡次余额',
  `total_points` int(11) DEFAULT '0' COMMENT '剩余积分',
  `used_points` int(11) DEFAULT '0' COMMENT '累计积分',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员表';

-- ----------------------------
-- Records of ky_member
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_member_balance_log
-- ----------------------------
DROP TABLE IF EXISTS `ky_member_balance_log`;
CREATE TABLE `ky_member_balance_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL COMMENT '会员ID',
  `order_id` int(11) DEFAULT NULL COMMENT '关联订单ID',
  `amount` decimal(10,2) NOT NULL COMMENT '变动金额',
  `type` tinyint(4) NOT NULL COMMENT '变动类型：1充值，2消费，3退款，4管理员调整',
  `before_balance` decimal(10,2) NOT NULL COMMENT '变动前余额',
  `after_balance` decimal(10,2) NOT NULL COMMENT '变动后余额',
  `operator_id` int(11) DEFAULT NULL COMMENT '操作人ID',
  `store_id` int(11) DEFAULT NULL COMMENT '门店ID',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_member_id` (`member_id`) USING BTREE,
  KEY `idx_order_id` (`order_id`) USING BTREE,
  KEY `idx_type` (`type`) USING BTREE,
  KEY `idx_created_at` (`created_at`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员余额变动记录表';

-- ----------------------------
-- Records of ky_member_balance_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_member_card
-- ----------------------------
DROP TABLE IF EXISTS `ky_member_card`;
CREATE TABLE `ky_member_card` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `card_no` varchar(20) NOT NULL COMMENT '卡号',
  `prefix` varchar(10) NOT NULL COMMENT '前缀',
  `number` int(11) NOT NULL COMMENT '序号',
  `check_digit` char(1) DEFAULT NULL COMMENT '校验位',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0未使用 1已使用 2已作废',
  `member_id` int(11) DEFAULT NULL COMMENT '会员ID',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_card_no` (`card_no`) USING BTREE,
  KEY `idx_status` (`status`) USING BTREE,
  KEY `idx_member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100501 DEFAULT CHARSET=utf8mb4 COMMENT='会员卡';

-- ----------------------------
-- Records of ky_member_card
-- ----------------------------
BEGIN;
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100000, 'VIP100000', 'VIP', 100000, '0', 0, 0, '2025-02-15 14:10:36', '2025-04-02 17:52:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100001, 'VIP100001', 'VIP', 100001, '2', 0, 0, '2025-02-15 14:11:04', '2025-04-02 17:52:06');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100002, 'VIP100002', 'VIP', 100002, '3', 0, 0, '2025-02-15 14:11:04', '2025-04-02 17:52:07');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100003, 'VIP100003', 'VIP', 100003, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100004, 'VIP100004', 'VIP', 100004, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100005, 'VIP100005', 'VIP', 100005, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100006, 'VIP100006', 'VIP', 100006, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100007, 'VIP100007', 'VIP', 100007, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100008, 'VIP100008', 'VIP', 100008, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100009, 'VIP100009', 'VIP', 100009, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100010, 'VIP100010', 'VIP', 100010, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100011, 'VIP100011', 'VIP', 100011, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100012, 'VIP100012', 'VIP', 100012, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100013, 'VIP100013', 'VIP', 100013, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100014, 'VIP100014', 'VIP', 100014, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100015, 'VIP100015', 'VIP', 100015, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100016, 'VIP100016', 'VIP', 100016, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100017, 'VIP100017', 'VIP', 100017, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100018, 'VIP100018', 'VIP', 100018, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100019, 'VIP100019', 'VIP', 100019, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100020, 'VIP100020', 'VIP', 100020, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100021, 'VIP100021', 'VIP', 100021, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100022, 'VIP100022', 'VIP', 100022, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100023, 'VIP100023', 'VIP', 100023, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100024, 'VIP100024', 'VIP', 100024, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100025, 'VIP100025', 'VIP', 100025, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100026, 'VIP100026', 'VIP', 100026, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100027, 'VIP100027', 'VIP', 100027, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100028, 'VIP100028', 'VIP', 100028, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100029, 'VIP100029', 'VIP', 100029, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100030, 'VIP100030', 'VIP', 100030, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100031, 'VIP100031', 'VIP', 100031, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100032, 'VIP100032', 'VIP', 100032, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100033, 'VIP100033', 'VIP', 100033, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100034, 'VIP100034', 'VIP', 100034, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100035, 'VIP100035', 'VIP', 100035, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100036, 'VIP100036', 'VIP', 100036, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100037, 'VIP100037', 'VIP', 100037, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100038, 'VIP100038', 'VIP', 100038, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100039, 'VIP100039', 'VIP', 100039, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100040, 'VIP100040', 'VIP', 100040, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100041, 'VIP100041', 'VIP', 100041, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100042, 'VIP100042', 'VIP', 100042, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100043, 'VIP100043', 'VIP', 100043, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100044, 'VIP100044', 'VIP', 100044, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100045, 'VIP100045', 'VIP', 100045, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100046, 'VIP100046', 'VIP', 100046, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100047, 'VIP100047', 'VIP', 100047, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100048, 'VIP100048', 'VIP', 100048, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100049, 'VIP100049', 'VIP', 100049, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100050, 'VIP100050', 'VIP', 100050, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100051, 'VIP100051', 'VIP', 100051, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100052, 'VIP100052', 'VIP', 100052, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100053, 'VIP100053', 'VIP', 100053, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100054, 'VIP100054', 'VIP', 100054, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100055, 'VIP100055', 'VIP', 100055, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100056, 'VIP100056', 'VIP', 100056, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100057, 'VIP100057', 'VIP', 100057, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100058, 'VIP100058', 'VIP', 100058, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100059, 'VIP100059', 'VIP', 100059, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100060, 'VIP100060', 'VIP', 100060, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100061, 'VIP100061', 'VIP', 100061, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100062, 'VIP100062', 'VIP', 100062, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100063, 'VIP100063', 'VIP', 100063, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100064, 'VIP100064', 'VIP', 100064, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100065, 'VIP100065', 'VIP', 100065, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100066, 'VIP100066', 'VIP', 100066, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100067, 'VIP100067', 'VIP', 100067, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100068, 'VIP100068', 'VIP', 100068, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100069, 'VIP100069', 'VIP', 100069, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100070, 'VIP100070', 'VIP', 100070, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100071, 'VIP100071', 'VIP', 100071, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100072, 'VIP100072', 'VIP', 100072, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100073, 'VIP100073', 'VIP', 100073, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100074, 'VIP100074', 'VIP', 100074, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100075, 'VIP100075', 'VIP', 100075, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100076, 'VIP100076', 'VIP', 100076, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100077, 'VIP100077', 'VIP', 100077, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100078, 'VIP100078', 'VIP', 100078, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100079, 'VIP100079', 'VIP', 100079, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100080, 'VIP100080', 'VIP', 100080, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100081, 'VIP100081', 'VIP', 100081, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100082, 'VIP100082', 'VIP', 100082, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100083, 'VIP100083', 'VIP', 100083, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100084, 'VIP100084', 'VIP', 100084, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100085, 'VIP100085', 'VIP', 100085, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100086, 'VIP100086', 'VIP', 100086, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100087, 'VIP100087', 'VIP', 100087, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100088, 'VIP100088', 'VIP', 100088, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100089, 'VIP100089', 'VIP', 100089, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100090, 'VIP100090', 'VIP', 100090, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100091, 'VIP100091', 'VIP', 100091, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100092, 'VIP100092', 'VIP', 100092, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100093, 'VIP100093', 'VIP', 100093, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100094, 'VIP100094', 'VIP', 100094, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100095, 'VIP100095', 'VIP', 100095, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100096, 'VIP100096', 'VIP', 100096, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100097, 'VIP100097', 'VIP', 100097, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100098, 'VIP100098', 'VIP', 100098, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100099, 'VIP100099', 'VIP', 100099, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100100, 'VIP100100', 'VIP', 100100, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100101, 'VIP100101', 'VIP', 100101, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100102, 'VIP100102', 'VIP', 100102, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100103, 'VIP100103', 'VIP', 100103, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100104, 'VIP100104', 'VIP', 100104, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100105, 'VIP100105', 'VIP', 100105, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100106, 'VIP100106', 'VIP', 100106, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100107, 'VIP100107', 'VIP', 100107, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100108, 'VIP100108', 'VIP', 100108, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100109, 'VIP100109', 'VIP', 100109, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100110, 'VIP100110', 'VIP', 100110, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100111, 'VIP100111', 'VIP', 100111, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100112, 'VIP100112', 'VIP', 100112, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100113, 'VIP100113', 'VIP', 100113, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100114, 'VIP100114', 'VIP', 100114, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100115, 'VIP100115', 'VIP', 100115, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100116, 'VIP100116', 'VIP', 100116, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100117, 'VIP100117', 'VIP', 100117, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100118, 'VIP100118', 'VIP', 100118, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100119, 'VIP100119', 'VIP', 100119, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100120, 'VIP100120', 'VIP', 100120, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100121, 'VIP100121', 'VIP', 100121, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100122, 'VIP100122', 'VIP', 100122, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100123, 'VIP100123', 'VIP', 100123, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100124, 'VIP100124', 'VIP', 100124, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100125, 'VIP100125', 'VIP', 100125, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100126, 'VIP100126', 'VIP', 100126, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100127, 'VIP100127', 'VIP', 100127, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100128, 'VIP100128', 'VIP', 100128, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100129, 'VIP100129', 'VIP', 100129, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100130, 'VIP100130', 'VIP', 100130, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100131, 'VIP100131', 'VIP', 100131, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100132, 'VIP100132', 'VIP', 100132, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100133, 'VIP100133', 'VIP', 100133, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100134, 'VIP100134', 'VIP', 100134, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100135, 'VIP100135', 'VIP', 100135, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100136, 'VIP100136', 'VIP', 100136, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100137, 'VIP100137', 'VIP', 100137, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100138, 'VIP100138', 'VIP', 100138, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100139, 'VIP100139', 'VIP', 100139, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100140, 'VIP100140', 'VIP', 100140, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100141, 'VIP100141', 'VIP', 100141, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100142, 'VIP100142', 'VIP', 100142, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100143, 'VIP100143', 'VIP', 100143, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100144, 'VIP100144', 'VIP', 100144, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100145, 'VIP100145', 'VIP', 100145, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100146, 'VIP100146', 'VIP', 100146, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100147, 'VIP100147', 'VIP', 100147, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100148, 'VIP100148', 'VIP', 100148, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100149, 'VIP100149', 'VIP', 100149, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100150, 'VIP100150', 'VIP', 100150, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100151, 'VIP100151', 'VIP', 100151, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100152, 'VIP100152', 'VIP', 100152, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100153, 'VIP100153', 'VIP', 100153, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100154, 'VIP100154', 'VIP', 100154, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100155, 'VIP100155', 'VIP', 100155, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100156, 'VIP100156', 'VIP', 100156, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100157, 'VIP100157', 'VIP', 100157, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100158, 'VIP100158', 'VIP', 100158, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100159, 'VIP100159', 'VIP', 100159, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100160, 'VIP100160', 'VIP', 100160, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100161, 'VIP100161', 'VIP', 100161, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100162, 'VIP100162', 'VIP', 100162, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100163, 'VIP100163', 'VIP', 100163, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100164, 'VIP100164', 'VIP', 100164, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100165, 'VIP100165', 'VIP', 100165, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100166, 'VIP100166', 'VIP', 100166, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100167, 'VIP100167', 'VIP', 100167, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100168, 'VIP100168', 'VIP', 100168, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100169, 'VIP100169', 'VIP', 100169, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100170, 'VIP100170', 'VIP', 100170, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100171, 'VIP100171', 'VIP', 100171, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100172, 'VIP100172', 'VIP', 100172, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100173, 'VIP100173', 'VIP', 100173, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100174, 'VIP100174', 'VIP', 100174, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100175, 'VIP100175', 'VIP', 100175, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100176, 'VIP100176', 'VIP', 100176, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100177, 'VIP100177', 'VIP', 100177, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100178, 'VIP100178', 'VIP', 100178, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100179, 'VIP100179', 'VIP', 100179, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100180, 'VIP100180', 'VIP', 100180, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100181, 'VIP100181', 'VIP', 100181, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100182, 'VIP100182', 'VIP', 100182, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100183, 'VIP100183', 'VIP', 100183, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100184, 'VIP100184', 'VIP', 100184, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100185, 'VIP100185', 'VIP', 100185, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100186, 'VIP100186', 'VIP', 100186, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100187, 'VIP100187', 'VIP', 100187, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100188, 'VIP100188', 'VIP', 100188, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100189, 'VIP100189', 'VIP', 100189, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100190, 'VIP100190', 'VIP', 100190, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100191, 'VIP100191', 'VIP', 100191, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100192, 'VIP100192', 'VIP', 100192, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100193, 'VIP100193', 'VIP', 100193, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100194, 'VIP100194', 'VIP', 100194, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100195, 'VIP100195', 'VIP', 100195, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100196, 'VIP100196', 'VIP', 100196, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100197, 'VIP100197', 'VIP', 100197, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100198, 'VIP100198', 'VIP', 100198, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100199, 'VIP100199', 'VIP', 100199, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100200, 'VIP100200', 'VIP', 100200, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100201, 'VIP100201', 'VIP', 100201, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100202, 'VIP100202', 'VIP', 100202, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100203, 'VIP100203', 'VIP', 100203, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100204, 'VIP100204', 'VIP', 100204, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100205, 'VIP100205', 'VIP', 100205, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100206, 'VIP100206', 'VIP', 100206, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100207, 'VIP100207', 'VIP', 100207, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100208, 'VIP100208', 'VIP', 100208, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100209, 'VIP100209', 'VIP', 100209, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100210, 'VIP100210', 'VIP', 100210, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100211, 'VIP100211', 'VIP', 100211, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100212, 'VIP100212', 'VIP', 100212, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100213, 'VIP100213', 'VIP', 100213, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100214, 'VIP100214', 'VIP', 100214, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100215, 'VIP100215', 'VIP', 100215, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100216, 'VIP100216', 'VIP', 100216, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100217, 'VIP100217', 'VIP', 100217, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100218, 'VIP100218', 'VIP', 100218, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100219, 'VIP100219', 'VIP', 100219, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100220, 'VIP100220', 'VIP', 100220, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100221, 'VIP100221', 'VIP', 100221, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100222, 'VIP100222', 'VIP', 100222, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100223, 'VIP100223', 'VIP', 100223, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100224, 'VIP100224', 'VIP', 100224, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100225, 'VIP100225', 'VIP', 100225, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100226, 'VIP100226', 'VIP', 100226, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100227, 'VIP100227', 'VIP', 100227, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100228, 'VIP100228', 'VIP', 100228, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100229, 'VIP100229', 'VIP', 100229, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100230, 'VIP100230', 'VIP', 100230, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100231, 'VIP100231', 'VIP', 100231, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100232, 'VIP100232', 'VIP', 100232, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100233, 'VIP100233', 'VIP', 100233, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100234, 'VIP100234', 'VIP', 100234, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100235, 'VIP100235', 'VIP', 100235, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100236, 'VIP100236', 'VIP', 100236, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100237, 'VIP100237', 'VIP', 100237, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100238, 'VIP100238', 'VIP', 100238, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100239, 'VIP100239', 'VIP', 100239, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100240, 'VIP100240', 'VIP', 100240, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100241, 'VIP100241', 'VIP', 100241, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100242, 'VIP100242', 'VIP', 100242, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100243, 'VIP100243', 'VIP', 100243, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100244, 'VIP100244', 'VIP', 100244, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100245, 'VIP100245', 'VIP', 100245, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100246, 'VIP100246', 'VIP', 100246, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100247, 'VIP100247', 'VIP', 100247, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100248, 'VIP100248', 'VIP', 100248, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100249, 'VIP100249', 'VIP', 100249, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100250, 'VIP100250', 'VIP', 100250, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100251, 'VIP100251', 'VIP', 100251, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100252, 'VIP100252', 'VIP', 100252, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100253, 'VIP100253', 'VIP', 100253, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100254, 'VIP100254', 'VIP', 100254, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100255, 'VIP100255', 'VIP', 100255, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100256, 'VIP100256', 'VIP', 100256, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100257, 'VIP100257', 'VIP', 100257, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100258, 'VIP100258', 'VIP', 100258, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100259, 'VIP100259', 'VIP', 100259, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100260, 'VIP100260', 'VIP', 100260, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100261, 'VIP100261', 'VIP', 100261, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100262, 'VIP100262', 'VIP', 100262, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100263, 'VIP100263', 'VIP', 100263, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100264, 'VIP100264', 'VIP', 100264, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100265, 'VIP100265', 'VIP', 100265, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100266, 'VIP100266', 'VIP', 100266, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100267, 'VIP100267', 'VIP', 100267, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100268, 'VIP100268', 'VIP', 100268, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100269, 'VIP100269', 'VIP', 100269, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100270, 'VIP100270', 'VIP', 100270, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100271, 'VIP100271', 'VIP', 100271, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100272, 'VIP100272', 'VIP', 100272, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100273, 'VIP100273', 'VIP', 100273, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100274, 'VIP100274', 'VIP', 100274, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100275, 'VIP100275', 'VIP', 100275, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100276, 'VIP100276', 'VIP', 100276, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100277, 'VIP100277', 'VIP', 100277, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100278, 'VIP100278', 'VIP', 100278, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100279, 'VIP100279', 'VIP', 100279, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100280, 'VIP100280', 'VIP', 100280, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100281, 'VIP100281', 'VIP', 100281, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100282, 'VIP100282', 'VIP', 100282, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100283, 'VIP100283', 'VIP', 100283, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100284, 'VIP100284', 'VIP', 100284, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100285, 'VIP100285', 'VIP', 100285, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100286, 'VIP100286', 'VIP', 100286, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100287, 'VIP100287', 'VIP', 100287, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100288, 'VIP100288', 'VIP', 100288, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100289, 'VIP100289', 'VIP', 100289, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100290, 'VIP100290', 'VIP', 100290, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100291, 'VIP100291', 'VIP', 100291, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100292, 'VIP100292', 'VIP', 100292, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100293, 'VIP100293', 'VIP', 100293, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100294, 'VIP100294', 'VIP', 100294, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100295, 'VIP100295', 'VIP', 100295, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100296, 'VIP100296', 'VIP', 100296, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100297, 'VIP100297', 'VIP', 100297, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100298, 'VIP100298', 'VIP', 100298, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100299, 'VIP100299', 'VIP', 100299, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100300, 'VIP100300', 'VIP', 100300, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100301, 'VIP100301', 'VIP', 100301, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100302, 'VIP100302', 'VIP', 100302, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100303, 'VIP100303', 'VIP', 100303, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100304, 'VIP100304', 'VIP', 100304, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100305, 'VIP100305', 'VIP', 100305, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100306, 'VIP100306', 'VIP', 100306, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100307, 'VIP100307', 'VIP', 100307, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100308, 'VIP100308', 'VIP', 100308, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100309, 'VIP100309', 'VIP', 100309, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100310, 'VIP100310', 'VIP', 100310, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100311, 'VIP100311', 'VIP', 100311, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100312, 'VIP100312', 'VIP', 100312, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100313, 'VIP100313', 'VIP', 100313, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100314, 'VIP100314', 'VIP', 100314, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100315, 'VIP100315', 'VIP', 100315, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100316, 'VIP100316', 'VIP', 100316, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100317, 'VIP100317', 'VIP', 100317, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100318, 'VIP100318', 'VIP', 100318, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100319, 'VIP100319', 'VIP', 100319, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100320, 'VIP100320', 'VIP', 100320, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100321, 'VIP100321', 'VIP', 100321, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100322, 'VIP100322', 'VIP', 100322, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100323, 'VIP100323', 'VIP', 100323, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100324, 'VIP100324', 'VIP', 100324, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100325, 'VIP100325', 'VIP', 100325, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100326, 'VIP100326', 'VIP', 100326, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100327, 'VIP100327', 'VIP', 100327, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100328, 'VIP100328', 'VIP', 100328, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100329, 'VIP100329', 'VIP', 100329, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100330, 'VIP100330', 'VIP', 100330, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100331, 'VIP100331', 'VIP', 100331, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100332, 'VIP100332', 'VIP', 100332, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100333, 'VIP100333', 'VIP', 100333, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100334, 'VIP100334', 'VIP', 100334, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100335, 'VIP100335', 'VIP', 100335, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100336, 'VIP100336', 'VIP', 100336, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100337, 'VIP100337', 'VIP', 100337, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100338, 'VIP100338', 'VIP', 100338, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100339, 'VIP100339', 'VIP', 100339, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100340, 'VIP100340', 'VIP', 100340, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100341, 'VIP100341', 'VIP', 100341, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100342, 'VIP100342', 'VIP', 100342, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100343, 'VIP100343', 'VIP', 100343, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100344, 'VIP100344', 'VIP', 100344, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100345, 'VIP100345', 'VIP', 100345, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100346, 'VIP100346', 'VIP', 100346, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100347, 'VIP100347', 'VIP', 100347, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100348, 'VIP100348', 'VIP', 100348, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100349, 'VIP100349', 'VIP', 100349, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100350, 'VIP100350', 'VIP', 100350, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100351, 'VIP100351', 'VIP', 100351, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100352, 'VIP100352', 'VIP', 100352, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100353, 'VIP100353', 'VIP', 100353, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100354, 'VIP100354', 'VIP', 100354, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100355, 'VIP100355', 'VIP', 100355, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100356, 'VIP100356', 'VIP', 100356, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100357, 'VIP100357', 'VIP', 100357, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100358, 'VIP100358', 'VIP', 100358, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100359, 'VIP100359', 'VIP', 100359, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100360, 'VIP100360', 'VIP', 100360, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100361, 'VIP100361', 'VIP', 100361, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100362, 'VIP100362', 'VIP', 100362, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100363, 'VIP100363', 'VIP', 100363, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100364, 'VIP100364', 'VIP', 100364, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100365, 'VIP100365', 'VIP', 100365, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100366, 'VIP100366', 'VIP', 100366, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100367, 'VIP100367', 'VIP', 100367, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100368, 'VIP100368', 'VIP', 100368, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100369, 'VIP100369', 'VIP', 100369, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100370, 'VIP100370', 'VIP', 100370, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100371, 'VIP100371', 'VIP', 100371, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100372, 'VIP100372', 'VIP', 100372, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100373, 'VIP100373', 'VIP', 100373, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100374, 'VIP100374', 'VIP', 100374, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100375, 'VIP100375', 'VIP', 100375, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100376, 'VIP100376', 'VIP', 100376, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100377, 'VIP100377', 'VIP', 100377, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100378, 'VIP100378', 'VIP', 100378, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100379, 'VIP100379', 'VIP', 100379, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100380, 'VIP100380', 'VIP', 100380, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100381, 'VIP100381', 'VIP', 100381, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100382, 'VIP100382', 'VIP', 100382, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100383, 'VIP100383', 'VIP', 100383, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100384, 'VIP100384', 'VIP', 100384, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100385, 'VIP100385', 'VIP', 100385, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100386, 'VIP100386', 'VIP', 100386, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100387, 'VIP100387', 'VIP', 100387, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100388, 'VIP100388', 'VIP', 100388, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100389, 'VIP100389', 'VIP', 100389, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100390, 'VIP100390', 'VIP', 100390, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100391, 'VIP100391', 'VIP', 100391, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100392, 'VIP100392', 'VIP', 100392, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100393, 'VIP100393', 'VIP', 100393, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100394, 'VIP100394', 'VIP', 100394, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100395, 'VIP100395', 'VIP', 100395, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100396, 'VIP100396', 'VIP', 100396, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100397, 'VIP100397', 'VIP', 100397, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100398, 'VIP100398', 'VIP', 100398, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100399, 'VIP100399', 'VIP', 100399, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100400, 'VIP100400', 'VIP', 100400, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100401, 'VIP100401', 'VIP', 100401, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100402, 'VIP100402', 'VIP', 100402, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100403, 'VIP100403', 'VIP', 100403, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100404, 'VIP100404', 'VIP', 100404, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100405, 'VIP100405', 'VIP', 100405, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100406, 'VIP100406', 'VIP', 100406, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100407, 'VIP100407', 'VIP', 100407, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100408, 'VIP100408', 'VIP', 100408, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100409, 'VIP100409', 'VIP', 100409, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100410, 'VIP100410', 'VIP', 100410, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100411, 'VIP100411', 'VIP', 100411, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100412, 'VIP100412', 'VIP', 100412, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100413, 'VIP100413', 'VIP', 100413, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100414, 'VIP100414', 'VIP', 100414, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100415, 'VIP100415', 'VIP', 100415, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100416, 'VIP100416', 'VIP', 100416, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100417, 'VIP100417', 'VIP', 100417, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100418, 'VIP100418', 'VIP', 100418, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100419, 'VIP100419', 'VIP', 100419, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100420, 'VIP100420', 'VIP', 100420, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100421, 'VIP100421', 'VIP', 100421, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100422, 'VIP100422', 'VIP', 100422, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100423, 'VIP100423', 'VIP', 100423, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100424, 'VIP100424', 'VIP', 100424, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100425, 'VIP100425', 'VIP', 100425, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100426, 'VIP100426', 'VIP', 100426, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100427, 'VIP100427', 'VIP', 100427, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100428, 'VIP100428', 'VIP', 100428, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100429, 'VIP100429', 'VIP', 100429, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100430, 'VIP100430', 'VIP', 100430, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100431, 'VIP100431', 'VIP', 100431, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100432, 'VIP100432', 'VIP', 100432, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100433, 'VIP100433', 'VIP', 100433, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100434, 'VIP100434', 'VIP', 100434, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100435, 'VIP100435', 'VIP', 100435, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100436, 'VIP100436', 'VIP', 100436, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100437, 'VIP100437', 'VIP', 100437, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100438, 'VIP100438', 'VIP', 100438, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100439, 'VIP100439', 'VIP', 100439, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100440, 'VIP100440', 'VIP', 100440, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100441, 'VIP100441', 'VIP', 100441, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100442, 'VIP100442', 'VIP', 100442, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100443, 'VIP100443', 'VIP', 100443, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100444, 'VIP100444', 'VIP', 100444, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100445, 'VIP100445', 'VIP', 100445, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100446, 'VIP100446', 'VIP', 100446, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100447, 'VIP100447', 'VIP', 100447, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100448, 'VIP100448', 'VIP', 100448, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100449, 'VIP100449', 'VIP', 100449, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100450, 'VIP100450', 'VIP', 100450, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100451, 'VIP100451', 'VIP', 100451, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100452, 'VIP100452', 'VIP', 100452, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100453, 'VIP100453', 'VIP', 100453, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100454, 'VIP100454', 'VIP', 100454, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100455, 'VIP100455', 'VIP', 100455, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100456, 'VIP100456', 'VIP', 100456, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100457, 'VIP100457', 'VIP', 100457, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100458, 'VIP100458', 'VIP', 100458, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100459, 'VIP100459', 'VIP', 100459, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100460, 'VIP100460', 'VIP', 100460, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100461, 'VIP100461', 'VIP', 100461, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100462, 'VIP100462', 'VIP', 100462, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100463, 'VIP100463', 'VIP', 100463, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100464, 'VIP100464', 'VIP', 100464, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100465, 'VIP100465', 'VIP', 100465, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100466, 'VIP100466', 'VIP', 100466, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100467, 'VIP100467', 'VIP', 100467, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100468, 'VIP100468', 'VIP', 100468, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100469, 'VIP100469', 'VIP', 100469, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100470, 'VIP100470', 'VIP', 100470, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100471, 'VIP100471', 'VIP', 100471, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100472, 'VIP100472', 'VIP', 100472, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100473, 'VIP100473', 'VIP', 100473, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100474, 'VIP100474', 'VIP', 100474, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100475, 'VIP100475', 'VIP', 100475, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100476, 'VIP100476', 'VIP', 100476, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100477, 'VIP100477', 'VIP', 100477, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100478, 'VIP100478', 'VIP', 100478, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100479, 'VIP100479', 'VIP', 100479, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100480, 'VIP100480', 'VIP', 100480, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100481, 'VIP100481', 'VIP', 100481, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100482, 'VIP100482', 'VIP', 100482, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100483, 'VIP100483', 'VIP', 100483, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100484, 'VIP100484', 'VIP', 100484, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100485, 'VIP100485', 'VIP', 100485, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100486, 'VIP100486', 'VIP', 100486, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100487, 'VIP100487', 'VIP', 100487, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100488, 'VIP100488', 'VIP', 100488, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100489, 'VIP100489', 'VIP', 100489, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100490, 'VIP100490', 'VIP', 100490, '4', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100491, 'VIP100491', 'VIP', 100491, '5', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100492, 'VIP100492', 'VIP', 100492, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100493, 'VIP100493', 'VIP', 100493, '7', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100494, 'VIP100494', 'VIP', 100494, '8', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100495, 'VIP100495', 'VIP', 100495, '9', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100496, 'VIP100496', 'VIP', 100496, '0', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100497, 'VIP100497', 'VIP', 100497, '1', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100498, 'VIP100498', 'VIP', 100498, '2', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100499, 'VIP100499', 'VIP', 100499, '3', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
INSERT INTO `ky_member_card` (`id`, `card_no`, `prefix`, `number`, `check_digit`, `status`, `member_id`, `created_at`, `updated_at`) VALUES (100500, 'VIP100500', 'VIP', 100500, '6', 0, NULL, '2025-02-15 14:11:04', '2025-02-15 14:11:04');
COMMIT;

-- ----------------------------
-- Table structure for ky_member_card_batch
-- ----------------------------
DROP TABLE IF EXISTS `ky_member_card_batch`;
CREATE TABLE `ky_member_card_batch` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prefix` varchar(10) NOT NULL COMMENT '前缀',
  `start_num` int(11) NOT NULL COMMENT '起始序号',
  `end_num` int(11) NOT NULL COMMENT '结束序号',
  `total` int(11) NOT NULL COMMENT '生成数量',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='会员卡批次';

-- ----------------------------
-- Records of ky_member_card_batch
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_member_consume
-- ----------------------------
DROP TABLE IF EXISTS `ky_member_consume`;
CREATE TABLE `ky_member_consume` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(30) NOT NULL COMMENT '订单号',
  `member_id` int(11) NOT NULL COMMENT '会员ID',
  `amount` decimal(10,2) NOT NULL COMMENT '消费金额',
  `discount_amount` decimal(10,2) NOT NULL COMMENT '优惠金额',
  `points` int(11) NOT NULL DEFAULT '0' COMMENT '获得积分',
  `operator_id` int(11) NOT NULL COMMENT '操作员ID',
  `store_id` int(11) NOT NULL COMMENT '门店ID',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='消费记录表';

-- ----------------------------
-- Records of ky_member_consume
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_member_level
-- ----------------------------
DROP TABLE IF EXISTS `ky_member_level`;
CREATE TABLE `ky_member_level` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '等级名称',
  `discount` decimal(10,2) NOT NULL DEFAULT '100.00' COMMENT '折扣率(%)',
  `min_charge` decimal(10,2) NOT NULL COMMENT '售卡工本费',
  `min_amount` decimal(10,2) NOT NULL COMMENT '初始充值金额',
  `discount_rate` decimal(3,2) NOT NULL DEFAULT '1.00' COMMENT '折扣率',
  `points_rate` decimal(3,2) NOT NULL DEFAULT '1.00' COMMENT '积分比例',
  `upgrade_points` int(11) NOT NULL DEFAULT '0' COMMENT '升级所需积分',
  `valid_days` int(11) NOT NULL DEFAULT '0' COMMENT '有效期(天)',
  `upgrade_level` int(11) DEFAULT NULL COMMENT '升级等级',
  `auto_upgrade` tinyint(1) NOT NULL DEFAULT '0' COMMENT '自动升级',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='会员等级表';

-- ----------------------------
-- Records of ky_member_level
-- ----------------------------
BEGIN;
INSERT INTO `ky_member_level` (`id`, `name`, `discount`, `min_charge`, `min_amount`, `discount_rate`, `points_rate`, `upgrade_points`, `valid_days`, `upgrade_level`, `auto_upgrade`, `status`, `remark`, `created_at`, `updated_at`) VALUES (1, 'VIP', 0.80, 0.00, 0.00, 1.00, 1.00, 100, 0, NULL, 0, 1, '', '2025-01-11 19:22:49', '2025-01-11 19:22:49');
COMMIT;

-- ----------------------------
-- Table structure for ky_member_recharge
-- ----------------------------
DROP TABLE IF EXISTS `ky_member_recharge`;
CREATE TABLE `ky_member_recharge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(30) NOT NULL COMMENT '订单号',
  `member_id` int(11) NOT NULL COMMENT '会员ID',
  `amount` decimal(10,2) NOT NULL COMMENT '充值金额',
  `give_amount` decimal(10,2) NOT NULL COMMENT '赠送金额',
  `payment_method` varchar(20) NOT NULL COMMENT '支付方式',
  `operator_id` int(11) NOT NULL COMMENT '操作员ID',
  `store_id` int(11) NOT NULL COMMENT '门店ID',
  `staff_id` int(11) DEFAULT NULL COMMENT '员工ID',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `modified_amount` decimal(10,2) DEFAULT NULL COMMENT '修正后的金额',
  `modify_reason` varchar(255) DEFAULT NULL COMMENT '修正原因',
  `modify_admin_id` int(11) DEFAULT NULL COMMENT '修正管理员ID',
  `modify_time` datetime DEFAULT NULL COMMENT '修正时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `member_id` (`member_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值记录表';

-- ----------------------------
-- Records of ky_member_recharge
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_operate_log
-- ----------------------------
DROP TABLE IF EXISTS `ky_operate_log`;
CREATE TABLE `ky_operate_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admin_id` int(11) NOT NULL DEFAULT '0' COMMENT '管理员ID',
  `admin_name` varchar(50) NOT NULL DEFAULT '' COMMENT '管理员用户名',
  `action` varchar(50) NOT NULL DEFAULT '' COMMENT '操作动作',
  `content` text COMMENT '操作内容',
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP地址',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_admin_id` (`admin_id`) USING BTREE,
  KEY `idx_created_at` (`created_at`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志表';

-- ----------------------------
-- Records of ky_operate_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_order
-- ----------------------------
DROP TABLE IF EXISTS `ky_order`;
CREATE TABLE `ky_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_no` varchar(50) NOT NULL COMMENT '订单号',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `store_id` int(11) NOT NULL COMMENT '门店ID',
  `staff_id` int(11) NOT NULL COMMENT '员工ID',
  `total_amount` decimal(10,2) NOT NULL COMMENT '总金额',
  `paid_amount` decimal(10,2) NOT NULL COMMENT '支付金额',
  `discount_amount` decimal(10,2) NOT NULL COMMENT '优惠金额',
  `points_used` int(11) NOT NULL DEFAULT '0' COMMENT '使用积分数量',
  `points_deduction_amount` decimal(10,2) NOT NULL COMMENT '积分抵扣金额',
  `points_earned` int(11) NOT NULL DEFAULT '0' COMMENT '获得积分',
  `status` tinyint(4) DEFAULT NULL COMMENT '订单状态;0=待支付,1=已支付,2=已退款,3=已过期,4=退款审核中,5-用户已取消,6=待使用,7=待发货,8已发货；9=已完成,10=已关闭',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `payment_time` datetime DEFAULT NULL COMMENT '支付时间',
  `is_pay` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否支付：0.未支付|1.已支付',
  `pay_type` tinyint(4) NOT NULL COMMENT '支付方式：1.在线支付 2.货到付款 3.余额支付',
  `is_coupon_used` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否使用优惠券',
  `is_points_used` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否使用积分',
  `is_verified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否核销',
  `verification_time` datetime DEFAULT NULL COMMENT '核销时间',
  `order_type` varchar(20) DEFAULT NULL COMMENT '订单类型',
  `is_refunded` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否退款',
  `refund_start_time` datetime DEFAULT NULL COMMENT '退款时间',
  `refund_success_time` datetime DEFAULT NULL COMMENT '售后完成时间',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_order_no` (`order_no`) USING BTREE,
  KEY `idx_user_id` (`user_id`) USING BTREE,
  KEY `idx_store_id` (`store_id`) USING BTREE,
  KEY `idx_staff_id` (`staff_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单表';

-- ----------------------------
-- Records of ky_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_order_goods
-- ----------------------------
DROP TABLE IF EXISTS `ky_order_goods`;
CREATE TABLE `ky_order_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单ID',
  `goods_id` int(11) NOT NULL COMMENT '商品ID',
  `goods_name` varchar(100) NOT NULL COMMENT '商品名称',
  `goods_price` decimal(10,2) NOT NULL COMMENT '商品单价',
  `quantity` int(11) NOT NULL COMMENT '购买数量',
  `total_amount` decimal(10,2) NOT NULL COMMENT '小计金额',
  `discount_amount` decimal(10,2) NOT NULL COMMENT '优惠金额',
  `final_amount` decimal(10,2) NOT NULL COMMENT '实付金额',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_order_id` (`order_id`) USING BTREE,
  KEY `idx_goods_id` (`goods_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单商品表';

-- ----------------------------
-- Records of ky_order_goods
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_order_payment
-- ----------------------------
DROP TABLE IF EXISTS `ky_order_payment`;
CREATE TABLE `ky_order_payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL COMMENT '订单ID',
  `payment_method` varchar(20) NOT NULL COMMENT '支付方式',
  `amount` decimal(10,2) NOT NULL COMMENT '支付金额',
  `transaction_no` varchar(100) DEFAULT NULL COMMENT '交易单号',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态：0未支付 1已支付 2已退款',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_order_id` (`order_id`) USING BTREE,
  KEY `idx_transaction_no` (`transaction_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单支付表';

-- ----------------------------
-- Records of ky_order_payment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_organization
-- ----------------------------
DROP TABLE IF EXISTS `ky_organization`;
CREATE TABLE `ky_organization` (
  `org_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '企业ID',
  `company_name` varchar(200) NOT NULL COMMENT '企业名称',
  `business_license` varchar(50) NOT NULL COMMENT '营业执照号',
  `legal_representative` varchar(50) NOT NULL COMMENT '法人姓名',
  `company_address` varchar(255) NOT NULL COMMENT '企业地址',
  `contact_phone` varchar(20) NOT NULL COMMENT '联系电话',
  `company_email` varchar(100) DEFAULT NULL COMMENT '企业邮箱',
  `invoice_type` enum('normal','special') NOT NULL COMMENT '开票类型：普票/专票',
  `tax_number` varchar(50) NOT NULL COMMENT '纳税人识别号',
  `bank_name` varchar(100) NOT NULL COMMENT '开户行',
  `bank_account` varchar(50) NOT NULL COMMENT '银行账号',
  `invoice_address` varchar(255) NOT NULL COMMENT '开票地址',
  `invoice_phone` varchar(20) NOT NULL COMMENT '开票电话',
  `contact_name` varchar(50) NOT NULL COMMENT '联系人姓名',
  `contact_mobile` varchar(20) NOT NULL COMMENT '联系人电话',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1-正常 0-禁用',
  `black_card_no` varchar(32) DEFAULT NULL COMMENT '关联黑卡卡号',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`org_id`),
  UNIQUE KEY `idx_business_license` (`business_license`),
  KEY `idx_black_card` (`black_card_no`),
  CONSTRAINT `fk_org_black_card` FOREIGN KEY (`black_card_no`) REFERENCES `ky_black_card` (`card_no`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='企业机构管理表';

-- ----------------------------
-- Records of ky_organization
-- ----------------------------
BEGIN;
INSERT INTO `ky_organization` (`org_id`, `company_name`, `business_license`, `legal_representative`, `company_address`, `contact_phone`, `company_email`, `invoice_type`, `tax_number`, `bank_name`, `bank_account`, `invoice_address`, `invoice_phone`, `contact_name`, `contact_mobile`, `status`, `black_card_no`, `created_at`, `updated_at`) VALUES (2, 'asfoasgdfsgd', 'fhgfjhkhjgkkkj', 'king xie', '漫云坊', '15168443394', 'sadfgf@qq.com', 'normal', '91330000XXXXXXXX', 'adasfsdg', 'fhtfdhghdf', 'asdfafd', '15148333394', 'asfddfgh', '15168443394', 1, NULL, '2025-06-10 10:36:51', '2025-06-10 10:36:51');
COMMIT;

-- ----------------------------
-- Table structure for ky_organization_change_log
-- ----------------------------
DROP TABLE IF EXISTS `ky_organization_change_log`;
CREATE TABLE `ky_organization_change_log` (
  `log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '记录ID',
  `org_id` bigint(20) NOT NULL COMMENT '企业ID',
  `change_type` enum('basic','contact','invoice','status','card') NOT NULL COMMENT '变更类型：基本信息/联系方式/开票信息/状态/黑卡',
  `change_field` varchar(50) NOT NULL COMMENT '变更字段',
  `old_value` text COMMENT '原值',
  `new_value` text COMMENT '新值',
  `operator_id` bigint(20) NOT NULL COMMENT '操作人ID',
  `operator_name` varchar(50) NOT NULL COMMENT '操作人姓名',
  `change_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '变更时间',
  `remark` varchar(500) DEFAULT NULL COMMENT '变更备注',
  PRIMARY KEY (`log_id`),
  KEY `idx_org_id` (`org_id`),
  KEY `idx_operator` (`operator_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='企业机构变更记录表';

-- ----------------------------
-- Records of ky_organization_change_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_points_log
-- ----------------------------
DROP TABLE IF EXISTS `ky_points_log`;
CREATE TABLE `ky_points_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member_id` int(11) NOT NULL COMMENT '会员ID',
  `points` int(11) NOT NULL COMMENT '积分变动',
  `type` tinyint(1) NOT NULL COMMENT '类型：1消费 2签到 3兑换 4调整',
  `order_id` int(11) DEFAULT NULL COMMENT '关联订单ID',
  `description` varchar(255) DEFAULT NULL COMMENT '说明',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `idx_member_id` (`member_id`) USING BTREE,
  KEY `idx_order_id` (`order_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='积分记录表';

-- ----------------------------
-- Records of ky_points_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_product_category
-- ----------------------------
DROP TABLE IF EXISTS `ky_product_category`;
CREATE TABLE `ky_product_category` (
  `category_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '分类ID',
  `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '父级ID',
  `name` varchar(50) NOT NULL COMMENT '分类名称',
  `level` tinyint(1) NOT NULL DEFAULT '1' COMMENT '层级：1-一级分类 2-二级分类',
  `path` varchar(255) DEFAULT '' COMMENT '分类路径',
  `icon` varchar(255) DEFAULT NULL COMMENT '分类图标',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序（数字越大越靠前）',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1-启用 0-禁用',
  `description` varchar(500) DEFAULT NULL COMMENT '分类描述',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`category_id`),
  KEY `idx_parent` (`parent_id`),
  KEY `idx_level` (`level`),
  KEY `idx_path` (`path`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品分类表';

-- ----------------------------
-- Records of ky_product_category
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_product_package_item
-- ----------------------------
DROP TABLE IF EXISTS `ky_product_package_item`;
CREATE TABLE `ky_product_package_item` (
  `item_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '明细ID',
  `product_id` bigint(20) NOT NULL COMMENT '产品ID',
  `sub_product_id` bigint(20) NOT NULL COMMENT '子产品ID',
  `quantity` int(11) NOT NULL DEFAULT '1' COMMENT '数量',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注说明',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`item_id`),
  KEY `idx_product` (`product_id`),
  KEY `idx_sub_product` (`sub_product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品套餐明细表';

-- ----------------------------
-- Records of ky_product_package_item
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_product_service_time
-- ----------------------------
DROP TABLE IF EXISTS `ky_product_service_time`;
CREATE TABLE `ky_product_service_time` (
  `time_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '时间ID',
  `product_id` bigint(20) NOT NULL COMMENT '产品ID',
  `service_date` date NOT NULL COMMENT '服务日期',
  `start_time` time NOT NULL COMMENT '开始时间',
  `end_time` time NOT NULL COMMENT '结束时间',
  `capacity` int(11) NOT NULL COMMENT '可预约人数',
  `booked_count` int(11) NOT NULL DEFAULT '0' COMMENT '已预约人数',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1-可预约 0-已约满',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`time_id`),
  KEY `idx_product_date` (`product_id`,`service_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品服务时间表';

-- ----------------------------
-- Records of ky_product_service_time
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_scenic_product
-- ----------------------------
DROP TABLE IF EXISTS `ky_scenic_product`;
CREATE TABLE `ky_scenic_product` (
  `product_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '产品ID',
  `category_id` bigint(20) NOT NULL COMMENT '分类ID',
  `scenic_spot_id` bigint(20) NOT NULL COMMENT '景区ID',
  `code` varchar(50) NOT NULL COMMENT '产品编码',
  `name` varchar(100) NOT NULL COMMENT '产品名称',
  `type` enum('package','single','service') NOT NULL COMMENT '产品类型：套餐/单品/服务',
  `price` decimal(12,2) NOT NULL COMMENT '标准价格',
  `black_card_price` decimal(12,2) NOT NULL COMMENT '黑卡价格',
  `original_price` decimal(12,2) DEFAULT NULL COMMENT '原价',
  `description` text COMMENT '产品描述',
  `features` text COMMENT '产品特色',
  `include_items` text COMMENT '包含项目',
  `exclude_items` text COMMENT '不包含项目',
  `notice` text COMMENT '使用须知',
  `cancel_rule` text COMMENT '取消规则',
  `validity_period` int(11) DEFAULT NULL COMMENT '有效期(天)',
  `reservation_notice` varchar(500) DEFAULT NULL COMMENT '预约说明',
  `min_people` int(11) DEFAULT '1' COMMENT '最小预订人数',
  `max_people` int(11) DEFAULT NULL COMMENT '最大预订人数',
  `images` text COMMENT '产品图片（JSON数组）',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1-在售 0-下架',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否特色产品',
  `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序（数字越大越靠前）',
  `sales_count` int(11) NOT NULL DEFAULT '0' COMMENT '销量',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`product_id`),
  UNIQUE KEY `idx_code` (`code`),
  KEY `idx_category` (`category_id`),
  KEY `idx_scenic_spot` (`scenic_spot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='景区产品表';

-- ----------------------------
-- Records of ky_scenic_product
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_scenic_spot
-- ----------------------------
DROP TABLE IF EXISTS `ky_scenic_spot`;
CREATE TABLE `ky_scenic_spot` (
  `scenic_spot_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '景区ID',
  `name` varchar(100) NOT NULL COMMENT '景区名称',
  `address` varchar(255) NOT NULL COMMENT '地址',
  `contact_phone` varchar(20) NOT NULL COMMENT '联系电话',
  `service_level` enum('premium','luxury','ultimate') NOT NULL COMMENT '服务等级',
  `cooperation_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '合作状态',
  `description` text COMMENT '景区描述',
  `services` text COMMENT '服务项目',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`scenic_spot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='景区信息表';

-- ----------------------------
-- Records of ky_scenic_spot
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_staff
-- ----------------------------
DROP TABLE IF EXISTS `ky_staff`;
CREATE TABLE `ky_staff` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `username` varchar(255) NOT NULL COMMENT '登录账号',
  `phone` varchar(15) NOT NULL,
  `password` varchar(255) NOT NULL,
  `store_id` int(11) DEFAULT NULL,
  `role` tinyint(4) NOT NULL DEFAULT '1',
  `admin_id` int(10) unsigned DEFAULT NULL,
  `position` varchar(50) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '1',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `phone` (`phone`) USING BTREE,
  KEY `store_id` (`store_id`) USING BTREE,
  CONSTRAINT `ky_staff_ibfk_1` FOREIGN KEY (`store_id`) REFERENCES `ky_store` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='员工管理';

-- ----------------------------
-- Records of ky_staff
-- ----------------------------
BEGIN;
INSERT INTO `ky_staff` (`id`, `name`, `username`, `phone`, `password`, `store_id`, `role`, `admin_id`, `position`, `status`, `created_at`, `updated_at`) VALUES (1, '希尔顿花园1', 'xedhy', '15168443398', '$2y$10$lOv7yP.XG/rYhdL8y4clPuxXif8k5Oe0IeelSMFONejq60/DGt.xC', 1, 2, 2, NULL, 1, '2025-02-07 16:09:48', '2025-06-04 17:24:04');
INSERT INTO `ky_staff` (`id`, `name`, `username`, `phone`, `password`, `store_id`, `role`, `admin_id`, `position`, `status`, `created_at`, `updated_at`) VALUES (9, '收营员', 'xedsyy', '15547753394', '$2y$10$ji2VHeSuBZruJ0wlf0wQHOOdrD81XlAcZIEdE8qKoUj5Ne40LpD3C', 1, 4, 9, NULL, 1, '2025-02-22 11:26:22', '2025-06-04 17:24:08');
COMMIT;

-- ----------------------------
-- Table structure for ky_store
-- ----------------------------
DROP TABLE IF EXISTS `ky_store`;
CREATE TABLE `ky_store` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '门店名称',
  `address` varchar(255) NOT NULL COMMENT '门店地址',
  `phone` varchar(20) NOT NULL COMMENT '联系电话',
  `manager_name` varchar(50) DEFAULT NULL COMMENT '负责人姓名',
  `manager_phone` varchar(20) DEFAULT NULL COMMENT '负责人电话',
  `business_hours` varchar(50) DEFAULT NULL COMMENT '营业时间',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：0禁用 1启用',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='门店管理';

-- ----------------------------
-- Records of ky_store
-- ----------------------------
BEGIN;
INSERT INTO `ky_store` (`id`, `name`, `address`, `phone`, `manager_name`, `manager_phone`, `business_hours`, `status`, `remark`, `created_at`, `updated_at`) VALUES (1, '希尔顿花园酒店', '内蒙古鄂尔多斯东胜区希尔顿酒店', '15168443394', '伊经理', '15168443394', '9:00', 1, '希尔顿花园酒店', '2025-01-11 17:19:18', '2025-02-15 09:16:07');
COMMIT;

-- ----------------------------
-- Table structure for ky_sub_card_member
-- ----------------------------
DROP TABLE IF EXISTS `ky_sub_card_member`;
CREATE TABLE `ky_sub_card_member` (
  `member_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '会员ID',
  `primary_card_id` bigint(20) NOT NULL COMMENT '主卡ID',
  `sub_card_id` bigint(20) NOT NULL COMMENT '子卡ID',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `member_name` varchar(50) NOT NULL COMMENT '会员姓名',
  `member_phone` varchar(20) NOT NULL COMMENT '会员手机号',
  `relation` varchar(50) DEFAULT NULL COMMENT '与主卡持有人关系',
  `quota_type` enum('fixed','shared') NOT NULL COMMENT '额度类型',
  `fixed_amount` decimal(12,2) DEFAULT NULL COMMENT '固定额度值',
  `shared_limit` decimal(12,2) DEFAULT NULL COMMENT '共享额度上限',
  `single_limit` decimal(12,2) DEFAULT NULL COMMENT '单次消费限额',
  `daily_limit` decimal(12,2) DEFAULT NULL COMMENT '日消费限额',
  `monthly_limit` decimal(12,2) DEFAULT NULL COMMENT '月消费限额',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1-正常 0-禁用',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`member_id`),
  UNIQUE KEY `idx_card_relation` (`primary_card_id`,`sub_card_id`),
  KEY `idx_primary_card` (`primary_card_id`),
  KEY `idx_sub_card` (`sub_card_id`),
  KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='子黑卡会员表';

-- ----------------------------
-- Records of ky_sub_card_member
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_transaction
-- ----------------------------
DROP TABLE IF EXISTS `ky_transaction`;
CREATE TABLE `ky_transaction` (
  `transaction_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '交易ID',
  `card_no` varchar(32) NOT NULL COMMENT '卡号',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `amount` decimal(12,2) NOT NULL COMMENT '交易金额',
  `type` enum('consumption','recharge','refund') NOT NULL COMMENT '交易类型',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '交易状态',
  `merchant_id` bigint(20) DEFAULT NULL COMMENT '商户ID',
  `description` varchar(255) DEFAULT NULL COMMENT '交易描述',
  `location` varchar(255) DEFAULT NULL COMMENT '交易地点',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '交易时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`transaction_id`),
  KEY `idx_card_no` (`card_no`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_merchant_id` (`merchant_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='交易记录表';

-- ----------------------------
-- Records of ky_transaction
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for ky_user
-- ----------------------------
DROP TABLE IF EXISTS `ky_user`;
CREATE TABLE `ky_user` (
  `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `type` enum('personal','organization') NOT NULL COMMENT '用户类型：个人/机构',
  `org_id` bigint(20) DEFAULT NULL COMMENT '企业机构ID',
  `black_card_no` varchar(32) DEFAULT NULL COMMENT '黑卡卡号',
  `balance` decimal(12,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户状态：0-禁用 1-正常',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `name` varchar(50) NOT NULL COMMENT '会员姓名',
  `phone` varchar(20) NOT NULL COMMENT '会员手机号',
  `id_card` varchar(18) DEFAULT NULL COMMENT '身份证号',
  `gender` enum('male','female','unknown') DEFAULT 'unknown' COMMENT '性别',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `birthday` date DEFAULT NULL COMMENT '出生日期',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `idx_phone` (`phone`),
  UNIQUE KEY `idx_id_card` (`id_card`),
  KEY `idx_org_id` (`org_id`),
  KEY `idx_black_card` (`black_card_no`),
  CONSTRAINT `fk_user_black_card` FOREIGN KEY (`black_card_no`) REFERENCES `ky_black_card` (`card_no`) ON DELETE SET NULL,
  CONSTRAINT `fk_user_org` FOREIGN KEY (`org_id`) REFERENCES `ky_organization` (`org_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of ky_user
-- ----------------------------
BEGIN;
INSERT INTO `ky_user` (`user_id`, `type`, `org_id`, `black_card_no`, `balance`, `status`, `remark`, `name`, `phone`, `id_card`, `gender`, `address`, `birthday`, `email`, `created_at`, `updated_at`) VALUES (1, 'personal', NULL, NULL, 0.00, 1, NULL, '杨林军', '15168443394', NULL, 'unknown', NULL, NULL, NULL, '2025-06-04 18:52:04', '2025-06-04 18:52:04');
COMMIT;

-- ----------------------------
-- Table structure for ky_user_account
-- ----------------------------
DROP TABLE IF EXISTS `ky_user_account`;
CREATE TABLE `ky_user_account` (
  `account_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '账号ID',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `username` varchar(50) NOT NULL COMMENT '登录用户名',
  `password` varchar(255) NOT NULL COMMENT '登录密码',
  `salt` varchar(32) NOT NULL COMMENT '密码盐值',
  `last_login_time` timestamp NULL DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(50) DEFAULT NULL COMMENT '最后登录IP',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态：1-正常 0-禁用',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`account_id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_user_id` (`user_id`),
  CONSTRAINT `fk_account_user` FOREIGN KEY (`user_id`) REFERENCES `ky_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户登录账号表';

-- ----------------------------
-- Records of ky_user_account
-- ----------------------------
BEGIN;
INSERT INTO `ky_user_account` (`account_id`, `user_id`, `username`, `password`, `salt`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (1, 1, 'yanglinjun', '$2y$10$zQD9Jx5sAWHsJWkemmt5Su5iax0FH0I2CxzeOqqf2MvFR1CfJzW2K', '0ea2222c7657a510e1bc5444ed4c01fc', NULL, NULL, 1, '2025-06-04 18:52:04', '2025-06-04 18:52:04');
COMMIT;

-- ----------------------------
-- Table structure for wa_admin_roles
-- ----------------------------
DROP TABLE IF EXISTS `wa_admin_roles`;
CREATE TABLE `wa_admin_roles` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `admin_id` int(11) NOT NULL COMMENT '管理员id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_admin_id` (`role_id`,`admin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='管理员角色表';

-- ----------------------------
-- Records of wa_admin_roles
-- ----------------------------
BEGIN;
INSERT INTO `wa_admin_roles` (`id`, `role_id`, `admin_id`) VALUES (1, 1, 1);
INSERT INTO `wa_admin_roles` (`id`, `role_id`, `admin_id`) VALUES (4, 2, 2);
INSERT INTO `wa_admin_roles` (`id`, `role_id`, `admin_id`) VALUES (5, 2, 9);
INSERT INTO `wa_admin_roles` (`id`, `role_id`, `admin_id`) VALUES (6, 2, 10);
INSERT INTO `wa_admin_roles` (`id`, `role_id`, `admin_id`) VALUES (9, 2, 12);
COMMIT;

-- ----------------------------
-- Table structure for wa_admins
-- ----------------------------
DROP TABLE IF EXISTS `wa_admins`;
CREATE TABLE `wa_admins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `nickname` varchar(40) NOT NULL COMMENT '昵称',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `avatar` varchar(255) DEFAULT '/app/admin/avatar.png' COMMENT '头像',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(16) DEFAULT NULL COMMENT '手机',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `login_at` datetime DEFAULT NULL COMMENT '登录时间',
  `status` tinyint(4) DEFAULT NULL COMMENT '禁用',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COMMENT='管理员表';

-- ----------------------------
-- Records of wa_admins
-- ----------------------------
BEGIN;
INSERT INTO `wa_admins` (`id`, `username`, `nickname`, `password`, `avatar`, `email`, `mobile`, `created_at`, `updated_at`, `login_at`, `status`) VALUES (1, 'admin', '超级管理员', '$2y$10$ZdTP6MjHCeXKrkBREXJgTe0pQaCJAJDb5lq5QgXr6gaEXZDJ890KK', '/app/admin/avatar.png', NULL, NULL, '2025-06-04 09:11:51', '2025-06-04 09:12:09', '2025-06-04 09:12:09', NULL);
INSERT INTO `wa_admins` (`id`, `username`, `nickname`, `password`, `avatar`, `email`, `mobile`, `created_at`, `updated_at`, `login_at`, `status`) VALUES (2, 'xedhy', '总管理', '$2y$10$re7WpdIBW0mkpwT2.EqvsegNKooF5r2Kl2oFMSqrxI7GdPQJiDHh6', '/app/admin/avatar.png', NULL, NULL, NULL, '2025-06-04 09:26:16', '2025-06-04 09:26:16', NULL);
INSERT INTO `wa_admins` (`id`, `username`, `nickname`, `password`, `avatar`, `email`, `mobile`, `created_at`, `updated_at`, `login_at`, `status`) VALUES (9, 'xedsyy', '收营员', '$2y$10$qj/pU3cHtoTieuoKYPFLIOfyl7tfsAIY2NmgVm8pdG1VOjaMgDMNi', '/app/admin/avatar.png', NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `wa_admins` (`id`, `username`, `nickname`, `password`, `avatar`, `email`, `mobile`, `created_at`, `updated_at`, `login_at`, `status`) VALUES (10, 'zhangxiaolan', '张晓兰', '$2y$10$exZ28GYz9prkNWiV8S8tB.Ykk6EavvyBLlDmvfxsEC8bdYJEKblTq', '/app/admin/avatar.png', NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for wa_options
-- ----------------------------
DROP TABLE IF EXISTS `wa_options`;
CREATE TABLE `wa_options` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL COMMENT '键',
  `value` longtext NOT NULL COMMENT '值',
  `created_at` datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '创建时间',
  `updated_at` datetime NOT NULL DEFAULT '2022-08-15 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COMMENT='选项表';

-- ----------------------------
-- Records of wa_options
-- ----------------------------
BEGIN;
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (1, 'system_config', '{\"logo\":{\"title\":\"Webman Admin\",\"image\":\"\\/app\\/admin\\/admin\\/images\\/logo.png\"},\"menu\":{\"data\":\"\\/app\\/admin\\/rule\\/get\",\"method\":\"GET\",\"accordion\":true,\"collapse\":false,\"control\":false,\"controlWidth\":500,\"select\":\"0\",\"async\":true},\"tab\":{\"enable\":true,\"keepState\":true,\"preload\":false,\"session\":true,\"max\":\"30\",\"index\":{\"id\":\"0\",\"href\":\"\\/app\\/admin\\/index\\/dashboard\",\"title\":\"\\u4eea\\u8868\\u76d8\"}},\"theme\":{\"defaultColor\":\"2\",\"defaultMenu\":\"light-theme\",\"defaultHeader\":\"light-theme\",\"allowCustom\":true,\"banner\":false},\"colors\":[{\"id\":\"1\",\"color\":\"#36b368\",\"second\":\"#f0f9eb\"},{\"id\":\"2\",\"color\":\"#2d8cf0\",\"second\":\"#ecf5ff\"},{\"id\":\"3\",\"color\":\"#f6ad55\",\"second\":\"#fdf6ec\"},{\"id\":\"4\",\"color\":\"#f56c6c\",\"second\":\"#fef0f0\"},{\"id\":\"5\",\"color\":\"#3963bc\",\"second\":\"#ecf5ff\"}],\"other\":{\"keepLoad\":\"500\",\"autoHead\":false,\"footer\":false},\"header\":{\"message\":false}}', '2022-12-05 14:49:01', '2022-12-08 20:20:28');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (2, 'table_form_schema_wa_users', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false},\"username\":{\"field\":\"username\",\"_field_id\":\"1\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"2\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"3\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"sex\":{\"field\":\"sex\",\"_field_id\":\"4\",\"comment\":\"性别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/sex\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"5\",\"comment\":\"头像\",\"control\":\"uploadImage\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/avatar\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"email\":{\"field\":\"email\",\"_field_id\":\"6\",\"comment\":\"邮箱\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"mobile\":{\"field\":\"mobile\",\"_field_id\":\"7\",\"comment\":\"手机\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"level\":{\"field\":\"level\",\"_field_id\":\"8\",\"comment\":\"等级\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"birthday\":{\"field\":\"birthday\",\"_field_id\":\"9\",\"comment\":\"生日\",\"control\":\"datePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"money\":{\"field\":\"money\",\"_field_id\":\"10\",\"comment\":\"余额(元)\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"score\":{\"field\":\"score\",\"_field_id\":\"11\",\"comment\":\"积分\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"last_time\":{\"field\":\"last_time\",\"_field_id\":\"12\",\"comment\":\"登录时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"last_ip\":{\"field\":\"last_ip\",\"_field_id\":\"13\",\"comment\":\"登录ip\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"join_time\":{\"field\":\"join_time\",\"_field_id\":\"14\",\"comment\":\"注册时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"join_ip\":{\"field\":\"join_ip\",\"_field_id\":\"15\",\"comment\":\"注册ip\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false},\"token\":{\"field\":\"token\",\"_field_id\":\"16\",\"comment\":\"token\",\"control\":\"input\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"17\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"18\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"between\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"role\":{\"field\":\"role\",\"_field_id\":\"19\",\"comment\":\"角色\",\"control\":\"inputNumber\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"20\",\"comment\":\"禁用\",\"control\":\"switch\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-23 15:28:13');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (3, 'table_form_schema_wa_roles', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"角色组\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"rules\":{\"field\":\"rules\",\"_field_id\":\"2\",\"comment\":\"权限\",\"control\":\"treeSelectMulti\",\"control_args\":\"url:\\/app\\/admin\\/rule\\/get?type=0,1,2\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"3\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"4\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"pid\":{\"field\":\"pid\",\"_field_id\":\"5\",\"comment\":\"父级\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/role\\/select?format=tree\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-19 14:24:25');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (4, 'table_form_schema_wa_rules', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"title\":{\"field\":\"title\",\"_field_id\":\"1\",\"comment\":\"标题\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"icon\":{\"field\":\"icon\",\"_field_id\":\"2\",\"comment\":\"图标\",\"control\":\"iconPicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"key\":{\"field\":\"key\",\"_field_id\":\"3\",\"comment\":\"标识\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"pid\":{\"field\":\"pid\",\"_field_id\":\"4\",\"comment\":\"上级菜单\",\"control\":\"treeSelect\",\"control_args\":\"\\/app\\/admin\\/rule\\/select?format=tree&type=0,1\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"5\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"6\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"href\":{\"field\":\"href\",\"_field_id\":\"7\",\"comment\":\"url\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"type\":{\"field\":\"type\",\"_field_id\":\"8\",\"comment\":\"类型\",\"control\":\"select\",\"control_args\":\"data:0:目录,1:菜单,2:权限\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"weight\":{\"field\":\"weight\",\"_field_id\":\"9\",\"comment\":\"排序\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-08 11:44:45');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (5, 'table_form_schema_wa_admins', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"ID\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"search_type\":\"between\",\"form_show\":false,\"searchable\":false},\"username\":{\"field\":\"username\",\"_field_id\":\"1\",\"comment\":\"用户名\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"nickname\":{\"field\":\"nickname\",\"_field_id\":\"2\",\"comment\":\"昵称\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"password\":{\"field\":\"password\",\"_field_id\":\"3\",\"comment\":\"密码\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"avatar\":{\"field\":\"avatar\",\"_field_id\":\"4\",\"comment\":\"头像\",\"control\":\"uploadImage\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/avatar\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"email\":{\"field\":\"email\",\"_field_id\":\"5\",\"comment\":\"邮箱\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"mobile\":{\"field\":\"mobile\",\"_field_id\":\"6\",\"comment\":\"手机\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"7\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"searchable\":true,\"search_type\":\"between\",\"list_show\":false,\"enable_sort\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"8\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"search_type\":\"normal\",\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"login_at\":{\"field\":\"login_at\",\"_field_id\":\"9\",\"comment\":\"登录时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"between\",\"enable_sort\":false,\"searchable\":false},\"status\":{\"field\":\"status\",\"_field_id\":\"10\",\"comment\":\"禁用\",\"control\":\"switch\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-23 15:36:48');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (6, 'table_form_schema_wa_options', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"键\",\"control\":\"input\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"value\":{\"field\":\"value\",\"_field_id\":\"2\",\"comment\":\"值\",\"control\":\"textArea\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"3\",\"comment\":\"创建时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"4\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-08 11:36:57');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (7, 'table_form_schema_wa_uploads', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"search_type\":\"normal\",\"form_show\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"名称\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"url\":{\"field\":\"url\",\"_field_id\":\"2\",\"comment\":\"文件\",\"control\":\"upload\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/file\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"3\",\"comment\":\"管理员\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/admin\\/select?format=select\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"file_size\":{\"field\":\"file_size\",\"_field_id\":\"4\",\"comment\":\"文件大小\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"mime_type\":{\"field\":\"mime_type\",\"_field_id\":\"5\",\"comment\":\"mime类型\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_width\":{\"field\":\"image_width\",\"_field_id\":\"6\",\"comment\":\"图片宽度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_height\":{\"field\":\"image_height\",\"_field_id\":\"7\",\"comment\":\"图片高度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"ext\":{\"field\":\"ext\",\"_field_id\":\"8\",\"comment\":\"扩展名\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"storage\":{\"field\":\"storage\",\"_field_id\":\"9\",\"comment\":\"存储位置\",\"control\":\"input\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"10\",\"comment\":\"上传时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"searchable\":true,\"search_type\":\"between\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false},\"category\":{\"field\":\"category\",\"_field_id\":\"11\",\"comment\":\"类别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/upload\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"12\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-08 11:47:45');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (8, 'table_form_schema_wa_uploads', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"search_type\":\"normal\",\"form_show\":false,\"searchable\":false},\"name\":{\"field\":\"name\",\"_field_id\":\"1\",\"comment\":\"名称\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"url\":{\"field\":\"url\",\"_field_id\":\"2\",\"comment\":\"文件\",\"control\":\"upload\",\"control_args\":\"url:\\/app\\/admin\\/upload\\/file\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"3\",\"comment\":\"管理员\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/admin\\/select?format=select\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"file_size\":{\"field\":\"file_size\",\"_field_id\":\"4\",\"comment\":\"文件大小\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"between\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"mime_type\":{\"field\":\"mime_type\",\"_field_id\":\"5\",\"comment\":\"mime类型\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_width\":{\"field\":\"image_width\",\"_field_id\":\"6\",\"comment\":\"图片宽度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"image_height\":{\"field\":\"image_height\",\"_field_id\":\"7\",\"comment\":\"图片高度\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false,\"searchable\":false},\"ext\":{\"field\":\"ext\",\"_field_id\":\"8\",\"comment\":\"扩展名\",\"control\":\"input\",\"control_args\":\"\",\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false,\"enable_sort\":false},\"storage\":{\"field\":\"storage\",\"_field_id\":\"9\",\"comment\":\"存储位置\",\"control\":\"input\",\"control_args\":\"\",\"search_type\":\"normal\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false,\"searchable\":false},\"created_at\":{\"field\":\"created_at\",\"_field_id\":\"10\",\"comment\":\"上传时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"searchable\":true,\"search_type\":\"between\",\"form_show\":false,\"list_show\":false,\"enable_sort\":false},\"category\":{\"field\":\"category\",\"_field_id\":\"11\",\"comment\":\"类别\",\"control\":\"select\",\"control_args\":\"url:\\/app\\/admin\\/dict\\/get\\/upload\",\"form_show\":true,\"list_show\":true,\"searchable\":true,\"search_type\":\"normal\",\"enable_sort\":false},\"updated_at\":{\"field\":\"updated_at\",\"_field_id\":\"12\",\"comment\":\"更新时间\",\"control\":\"dateTimePicker\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-08 11:47:45');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (9, 'dict_upload', '[{\"value\":\"1\",\"name\":\"分类1\"},{\"value\":\"2\",\"name\":\"分类2\"},{\"value\":\"3\",\"name\":\"分类3\"}]', '2022-12-04 16:24:13', '2022-12-04 16:24:13');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (10, 'dict_sex', '[{\"value\":\"0\",\"name\":\"女\"},{\"value\":\"1\",\"name\":\"男\"}]', '2022-12-04 15:04:40', '2022-12-04 15:04:40');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (11, 'dict_status', '[{\"value\":\"0\",\"name\":\"正常\"},{\"value\":\"1\",\"name\":\"禁用\"}]', '2022-12-04 15:05:09', '2022-12-04 15:05:09');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (17, 'table_form_schema_wa_admin_roles', '{\"id\":{\"field\":\"id\",\"_field_id\":\"0\",\"comment\":\"主键\",\"control\":\"inputNumber\",\"control_args\":\"\",\"list_show\":true,\"enable_sort\":true,\"searchable\":true,\"search_type\":\"normal\",\"form_show\":false},\"role_id\":{\"field\":\"role_id\",\"_field_id\":\"1\",\"comment\":\"角色id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false},\"admin_id\":{\"field\":\"admin_id\",\"_field_id\":\"2\",\"comment\":\"管理员id\",\"control\":\"inputNumber\",\"control_args\":\"\",\"form_show\":true,\"list_show\":true,\"search_type\":\"normal\",\"enable_sort\":false,\"searchable\":false}}', '2022-08-15 00:00:00', '2022-12-20 19:42:51');
INSERT INTO `wa_options` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (18, 'dict_dict_name', '[{\"value\":\"dict_name\",\"name\":\"字典名称\"},{\"value\":\"status\",\"name\":\"启禁用状态\"},{\"value\":\"sex\",\"name\":\"性别\"},{\"value\":\"upload\",\"name\":\"附件分类\"}]', '2022-08-15 00:00:00', '2022-12-20 19:42:51');
COMMIT;

-- ----------------------------
-- Table structure for wa_roles
-- ----------------------------
DROP TABLE IF EXISTS `wa_roles`;
CREATE TABLE `wa_roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(80) NOT NULL COMMENT '角色组',
  `rules` text COMMENT '权限',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  `pid` int(10) unsigned DEFAULT NULL COMMENT '父级',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COMMENT='管理员角色';

-- ----------------------------
-- Records of wa_roles
-- ----------------------------
BEGIN;
INSERT INTO `wa_roles` (`id`, `name`, `rules`, `created_at`, `updated_at`, `pid`) VALUES (1, '超级管理员', '*', '2022-08-13 16:15:01', '2022-12-23 12:05:07', NULL);
INSERT INTO `wa_roles` (`id`, `name`, `rules`, `created_at`, `updated_at`, `pid`) VALUES (2, '门店总管理', '88,89,90,91,77,78,79,80,81,82,83,84,85,86,87', '2025-02-03 17:57:58', '2025-02-03 17:57:58', 1);
INSERT INTO `wa_roles` (`id`, `name`, `rules`, `created_at`, `updated_at`, `pid`) VALUES (3, '店长', NULL, '2025-02-05 15:24:27', '2025-02-05 15:24:27', 1);
INSERT INTO `wa_roles` (`id`, `name`, `rules`, `created_at`, `updated_at`, `pid`) VALUES (4, '收银员', '65', '2025-02-05 15:24:51', '2025-02-05 15:25:08', 1);
COMMIT;

-- ----------------------------
-- Table structure for wa_rules
-- ----------------------------
DROP TABLE IF EXISTS `wa_rules`;
CREATE TABLE `wa_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(255) NOT NULL COMMENT '标题',
  `icon` varchar(255) DEFAULT NULL COMMENT '图标',
  `key` varchar(255) NOT NULL COMMENT '标识',
  `pid` int(10) unsigned DEFAULT '0' COMMENT '上级菜单',
  `created_at` datetime NOT NULL COMMENT '创建时间',
  `updated_at` datetime NOT NULL COMMENT '更新时间',
  `href` varchar(255) DEFAULT NULL COMMENT 'url',
  `type` int(11) NOT NULL DEFAULT '1' COMMENT '类型',
  `weight` int(11) DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COMMENT='权限规则';

-- ----------------------------
-- Records of wa_rules
-- ----------------------------
BEGIN;
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (1, '数据库', 'layui-icon-template-1', 'database', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 1000);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (2, '所有表', NULL, 'plugin\\admin\\app\\controller\\TableController', 1, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/table/index', 1, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (3, '权限管理', 'layui-icon-vercode', 'auth', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 900);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (4, '账户管理', NULL, 'plugin\\admin\\app\\controller\\AdminController', 3, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/admin/index', 1, 1000);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (5, '角色管理', NULL, 'plugin\\admin\\app\\controller\\RoleController', 3, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/role/index', 1, 900);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (6, '菜单管理', NULL, 'plugin\\admin\\app\\controller\\RuleController', 3, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/rule/index', 1, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (7, '会员管理', 'layui-icon-username', 'user', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (8, '用户', NULL, 'plugin\\admin\\app\\controller\\UserController', 7, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/user/index', 1, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (9, '通用设置', 'layui-icon-set', 'common', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 700);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (10, '个人资料', NULL, 'plugin\\admin\\app\\controller\\AccountController', 9, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/account/index', 1, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (11, '附件管理', NULL, 'plugin\\admin\\app\\controller\\UploadController', 9, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/upload/index', 1, 700);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (12, '字典设置', NULL, 'plugin\\admin\\app\\controller\\DictController', 9, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/dict/index', 1, 600);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (13, '系统设置', NULL, 'plugin\\admin\\app\\controller\\ConfigController', 9, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/config/index', 1, 500);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (14, '插件管理', 'layui-icon-app', 'plugin', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 600);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (15, '应用插件', NULL, 'plugin\\admin\\app\\controller\\PluginController', 14, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/plugin/index', 1, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (16, '开发辅助', 'layui-icon-fonts-code', 'dev', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 500);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (17, '表单构建', NULL, 'plugin\\admin\\app\\controller\\DevController', 16, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/dev/form-build', 1, 800);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (18, '示例页面', 'layui-icon-templeate-1', 'demos', 0, '2025-06-04 09:11:28', '2025-06-04 09:11:28', NULL, 0, 400);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (19, '工作空间', 'layui-icon-console', 'demo1', 18, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '', 0, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (20, '控制后台', 'layui-icon-console', 'demo10', 19, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/console/console1.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (21, '数据分析', 'layui-icon-console', 'demo13', 19, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/console/console2.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (22, '百度一下', 'layui-icon-console', 'demo14', 19, '2025-06-04 09:11:28', '2025-06-04 09:11:28', 'http://www.baidu.com', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (23, '主题预览', 'layui-icon-console', 'demo15', 19, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/theme.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (24, '常用组件', 'layui-icon-component', 'demo20', 18, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '', 0, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (25, '功能按钮', 'layui-icon-face-smile', 'demo2011', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/button.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (26, '表单集合', 'layui-icon-face-cry', 'demo2014', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/form.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (27, '字体图标', 'layui-icon-face-cry', 'demo2010', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/icon.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (28, '多选下拉', 'layui-icon-face-cry', 'demo2012', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/select.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (29, '动态标签', 'layui-icon-face-cry', 'demo2013', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/tag.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (30, '数据表格', 'layui-icon-face-cry', 'demo2031', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/table.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (31, '分布表单', 'layui-icon-face-cry', 'demo2032', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/step.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (32, '树形表格', 'layui-icon-face-cry', 'demo2033', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/treetable.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (33, '树状结构', 'layui-icon-face-cry', 'demo2034', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/dtree.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (34, '文本编辑', 'layui-icon-face-cry', 'demo2035', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/tinymce.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (35, '卡片组件', 'layui-icon-face-cry', 'demo2036', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/card.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (36, '抽屉组件', 'layui-icon-face-cry', 'demo2021', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/drawer.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (37, '消息通知', 'layui-icon-face-cry', 'demo2022', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/notice.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (38, '加载组件', 'layui-icon-face-cry', 'demo2024', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/loading.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (39, '弹层组件', 'layui-icon-face-cry', 'demo2023', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/popup.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (40, '多选项卡', 'layui-icon-face-cry', 'demo60131', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/tab.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (41, '数据菜单', 'layui-icon-face-cry', 'demo60132', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/menu.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (42, '哈希加密', 'layui-icon-face-cry', 'demo2041', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/encrypt.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (43, '图标选择', 'layui-icon-face-cry', 'demo2042', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/iconPicker.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (44, '省市级联', 'layui-icon-face-cry', 'demo2043', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/area.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (45, '数字滚动', 'layui-icon-face-cry', 'demo2044', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/count.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (46, '顶部返回', 'layui-icon-face-cry', 'demo2045', 24, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/document/topBar.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (47, '结果页面', 'layui-icon-auz', 'demo666', 18, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '', 0, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (48, '成功', 'layui-icon-face-smile', 'demo667', 47, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/result/success.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (49, '失败', 'layui-icon-face-cry', 'demo668', 47, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/result/error.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (50, '错误页面', 'layui-icon-face-cry', 'demo-error', 18, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '', 0, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (51, '403', 'layui-icon-face-smile', 'demo403', 50, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/error/403.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (52, '404', 'layui-icon-face-cry', 'demo404', 50, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/error/404.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (53, '500', 'layui-icon-face-cry', 'demo500', 50, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/error/500.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (54, '系统管理', 'layui-icon-set-fill', 'demo-system', 18, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '', 0, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (55, '用户管理', 'layui-icon-face-smile', 'demo601', 54, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/user.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (56, '角色管理', 'layui-icon-face-cry', 'demo602', 54, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/role.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (57, '权限管理', 'layui-icon-face-cry', 'demo603', 54, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/power.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (58, '部门管理', 'layui-icon-face-cry', 'demo604', 54, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/deptment.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (59, '行为日志', 'layui-icon-face-cry', 'demo605', 54, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/log.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (60, '数据字典', 'layui-icon-face-cry', 'demo606', 54, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/dict.html', 1, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (61, '常用页面', 'layui-icon-template-1', 'demo-common', 18, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '', 0, 0);
INSERT INTO `wa_rules` (`id`, `title`, `icon`, `key`, `pid`, `created_at`, `updated_at`, `href`, `type`, `weight`) VALUES (62, '空白页面', 'layui-icon-face-smile', 'demo702', 61, '2025-06-04 09:11:28', '2025-06-04 09:11:28', '/app/admin/demos/system/space.html', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for wa_uploads
-- ----------------------------
DROP TABLE IF EXISTS `wa_uploads`;
CREATE TABLE `wa_uploads` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(128) NOT NULL COMMENT '名称',
  `url` varchar(255) NOT NULL COMMENT '文件',
  `admin_id` int(11) DEFAULT NULL COMMENT '管理员',
  `file_size` int(11) NOT NULL COMMENT '文件大小',
  `mime_type` varchar(255) NOT NULL COMMENT 'mime类型',
  `image_width` int(11) DEFAULT NULL COMMENT '图片宽度',
  `image_height` int(11) DEFAULT NULL COMMENT '图片高度',
  `ext` varchar(128) NOT NULL COMMENT '扩展名',
  `storage` varchar(255) NOT NULL DEFAULT 'local' COMMENT '存储位置',
  `created_at` date DEFAULT NULL COMMENT '上传时间',
  `category` varchar(128) DEFAULT NULL COMMENT '类别',
  `updated_at` date DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  KEY `admin_id` (`admin_id`),
  KEY `name` (`name`),
  KEY `ext` (`ext`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='附件';

-- ----------------------------
-- Records of wa_uploads
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for wa_users
-- ----------------------------
DROP TABLE IF EXISTS `wa_users`;
CREATE TABLE `wa_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(32) NOT NULL COMMENT '用户名',
  `nickname` varchar(40) NOT NULL COMMENT '昵称',
  `password` varchar(255) NOT NULL COMMENT '密码',
  `sex` enum('0','1') NOT NULL DEFAULT '1' COMMENT '性别',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `email` varchar(128) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(16) DEFAULT NULL COMMENT '手机',
  `level` tinyint(4) NOT NULL DEFAULT '0' COMMENT '等级',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `money` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额(元)',
  `score` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
  `last_time` datetime DEFAULT NULL COMMENT '登录时间',
  `last_ip` varchar(50) DEFAULT NULL COMMENT '登录ip',
  `join_time` datetime DEFAULT NULL COMMENT '注册时间',
  `join_ip` varchar(50) DEFAULT NULL COMMENT '注册ip',
  `token` varchar(50) DEFAULT NULL COMMENT 'token',
  `created_at` datetime DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime DEFAULT NULL COMMENT '更新时间',
  `role` int(11) NOT NULL DEFAULT '1' COMMENT '角色',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '禁用',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `join_time` (`join_time`),
  KEY `mobile` (`mobile`),
  KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
-- Records of wa_users
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
